package com.billing.model.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.billing.model.entity.CrmContact;

public interface CrmContactMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(CrmContact record);

    int insertSelective(CrmContact record);

    CrmContact selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(CrmContact record);

    int updateByPrimaryKey(CrmContact record);
    
    int selectNum(@Param("userid")String userid,@Param("custid")String custid);
    
    int selectNumBylkmid(@Param("lkmid")String lkmid);

    List<CrmContact> selectPage(@Param("userid")String userid,@Param("custid")String custid,@Param("startRow")int startRow,@Param("pageSize")int pageSize);

    List<CrmContact> selectPageByLkmid(@Param("lkmid")String lkmid,@Param("startRow")int startRow,@Param("pageSize")int pageSize);

    List<CrmContact> selectContactByLkmid(@Param("lkmId")String lkmId);
    
    int countCustContactByMonthAndUserid(@Param("month")String month,@Param("userid")String userid);
    
    List<CrmContact> selectContactByCust(@Param("custId")String custId);
}